Date Format

cijjack

I have an user variable, value is set as '2010-01-20'. I try to display it on a text object with a date format as "dd mmm yyyy". It won't follow the format and just display "2010-01-20" instead. How do I convert it? Thank you in advance!

gordk

use the string to date function

cijjack

Thank you very much! I tried the following and it works. I think fastreport just follow the date style, such as 'dd/mm/yy', from Windows settings. If I set the variable string to '2010-01-01', then it will cause an error. Is that possible to let fastreport follow a style of 'yyyy-mm-dd' and while the Windows settings is 'dd/mm/yy'.

[StrToDate(<startday>)]

gordk wrote: »

use the string to date function

gpi

Use
[EncodeDate(StrToInt(Copy(<startday>, 1, 4)), StrToInt(Copy(<startday>, 6, 2)), StrToInt(Copy(<startday>, 9, 2)))]

cijjack

Thank you gpi, it works perfect! By testing the date format, I found something very interesting which is the query for report. The variables of startday and endday are provided for query's

cijjack

Sorry! It's ":p1" and ":p2".